#
# Table structure for table 'tx_chraetseltreff_print'
#
CREATE TABLE tx_chraetseltreff_print (
	uid int(11) NOT NULL auto_increment,
	pid int(11) DEFAULT '0' NOT NULL,
	tstamp int(11) DEFAULT '0' NOT NULL,
	crdate int(11) DEFAULT '0' NOT NULL,
	cruser_id int(11) DEFAULT '0' NOT NULL,
	sorting int(10) DEFAULT '0' NOT NULL,
    deleted tinyint(4) DEFAULT '0' NOT NULL,
	hidden tinyint(4) DEFAULT '0' NOT NULL,
	title tinytext,
	filename tinytext,
    suffix tinytext,
    evt_tag tinyint(4) DEFAULT '0' NOT NULL,
    evt_woche tinyint(4) DEFAULT '0' NOT NULL,
    taktung tinyint(4) DEFAULT '0' NOT NULL,
    replyemail tinytext,
    replyname tinytext,
    toemail tinytext,
    toname tinytext,
    emailsubject tinytext,
    emailbody tinytext,

    alt_template tinyint(4) DEFAULT '0' NOT NULL,
    email tinyint(4) DEFAULT '0' NOT NULL,
    special tinyint(4) DEFAULT '0' NOT NULL,
    
	PRIMARY KEY (uid),
	KEY parent (pid)
);

#
# Table structure for table 'tx_chraetseltreff_redaktion'
#
CREATE TABLE tx_chraetseltreff_redaktion (
	uid int(11) NOT NULL auto_increment,
	pid int(11) DEFAULT '0' NOT NULL,
	tstamp int(11) DEFAULT '0' NOT NULL,
	crdate int(11) DEFAULT '0' NOT NULL,
	cruser_id int(11) DEFAULT '0' NOT NULL,
	sorting int(10) DEFAULT '0' NOT NULL,
    deleted tinyint(4) DEFAULT '0' NOT NULL,
	hidden tinyint(4) DEFAULT '0' NOT NULL,
	emailreplyname tinytext,
    emailreplyemail tinytext,
    emailtoname tinytext,
    emailtoemail tinytext,
    emailsubject tinytext,
    emailbody tinytext
       
	PRIMARY KEY (uid),
	KEY parent (pid)
);

#
# Table structure for table 'tx_chraetseltreff_user'
#
CREATE TABLE tx_chraetseltreff_user (
	uid int(11) NOT NULL auto_increment,
	pid int(11) DEFAULT '0' NOT NULL,
	tstamp int(11) DEFAULT '0' NOT NULL,
	crdate int(11) DEFAULT '0' NOT NULL,
	cruser_id int(11) DEFAULT '0' NOT NULL,
	sorting int(10) DEFAULT '0' NOT NULL,
    deleted tinyint(4) DEFAULT '0' NOT NULL,
	hidden tinyint(4) DEFAULT '0' NOT NULL,
    vorname tinytext,
	name tinytext,
	strasse tinytext,
    hausnummer tinytext,
    plz tinytext,
    ort tinytext,
    email tinytext,
    telefon tinytext,
    hinweise tinytext,

    anrede tinyint(4) DEFAULT '0' NOT NULL,
    agb tinyint(4) DEFAULT '0' NOT NULL,
    werbung tinyint(4) DEFAULT '0' NOT NULL,
        
	PRIMARY KEY (uid),
	KEY parent (pid)
);

#
# Table structure for table 'tx_chraetseltreff_spiel'
#
CREATE TABLE tx_chraetseltreff_spiel (
	uid int(11) NOT NULL auto_increment,
	pid int(11) DEFAULT '0' NOT NULL,
	tstamp int(11) DEFAULT '0' NOT NULL,
	crdate int(11) DEFAULT '0' NOT NULL,
	cruser_id int(11) DEFAULT '0' NOT NULL,
	sorting int(10) DEFAULT '0' NOT NULL,
    deleted tinyint(4) DEFAULT '0' NOT NULL,
	hidden tinyint(4) DEFAULT '0' NOT NULL,
	title tinytext,
    print_id int(11) DEFAULT '0' NOT NULL,
    user_id int(11) DEFAULT '0' NOT NULL,
    kw int(11) DEFAULT '0' NOT NULL,
        
	PRIMARY KEY (uid),
	KEY parent (pid)
);

#
# Table structure for table 'tx_chraetseltreff_special'
#
CREATE TABLE tx_chraetseltreff_special (
	uid int(11) NOT NULL auto_increment,
	pid int(11) DEFAULT '0' NOT NULL,
	tstamp int(11) DEFAULT '0' NOT NULL,
	crdate int(11) DEFAULT '0' NOT NULL,
	cruser_id int(11) DEFAULT '0' NOT NULL,
	sorting int(10) DEFAULT '0' NOT NULL,
    deleted tinyint(4) DEFAULT '0' NOT NULL,
	hidden tinyint(4) DEFAULT '0' NOT NULL,
	title tinytext,
    specialdate int(11) DEFAULT '0' NOT NULL
       
	PRIMARY KEY (uid),
	KEY parent (pid)
);